Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 2256 |
| Missing cells | 12610 |
| Missing cells (%) | 26.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 808.1 KiB |
| Average record size in memory | 366.8 B |
Variable types
| DateTime | 2 |
|---|---|
| Numeric | 14 |
| Text | 1 |
| Categorical | 2 |
| Unsupported | 2 |
city_name has constant value "local" | Constant |
Autoconsumo (kWh) is highly overall correlated with Horário Económico (kWh) | High correlation |
Hora is highly overall correlated with Normal (kWh) | High correlation |
Horário Económico (kWh) is highly overall correlated with Autoconsumo (kWh) and 1 other fields | High correlation |
Normal (kWh) is highly overall correlated with Hora and 1 other fields | High correlation |
clouds_all is highly overall correlated with humidity and 1 other fields | High correlation |
feels_like is highly overall correlated with temp and 2 other fields | High correlation |
humidity is highly overall correlated with clouds_all | High correlation |
rain_1h is highly overall correlated with weather_description | High correlation |
temp is highly overall correlated with feels_like and 2 other fields | High correlation |
temp_max is highly overall correlated with feels_like and 2 other fields | High correlation |
temp_min is highly overall correlated with feels_like and 2 other fields | High correlation |
weather_description is highly overall correlated with clouds_all and 1 other fields | High correlation |
dt has 504 (22.3%) missing values | Missing |
dt_iso has 504 (22.3%) missing values | Missing |
city_name has 504 (22.3%) missing values | Missing |
temp has 504 (22.3%) missing values | Missing |
feels_like has 504 (22.3%) missing values | Missing |
temp_min has 504 (22.3%) missing values | Missing |
temp_max has 504 (22.3%) missing values | Missing |
pressure has 504 (22.3%) missing values | Missing |
sea_level has 2256 (100.0%) missing values | Missing |
grnd_level has 2256 (100.0%) missing values | Missing |
humidity has 504 (22.3%) missing values | Missing |
wind_speed has 504 (22.3%) missing values | Missing |
rain_1h has 2050 (90.9%) missing values | Missing |
clouds_all has 504 (22.3%) missing values | Missing |
weather_description has 504 (22.3%) missing values | Missing |
dt is uniformly distributed | Uniform |
DataHora has unique values | Unique |
sea_level is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
grnd_level is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Hora has 94 (4.2%) zeros | Zeros |
Normal (kWh) has 1225 (54.3%) zeros | Zeros |
Horário Económico (kWh) has 1317 (58.4%) zeros | Zeros |
Autoconsumo (kWh) has 1263 (56.0%) zeros | Zeros |
clouds_all has 504 (22.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-02 21:13:31.528028 |
|---|---|
| Analysis finished | 2025-11-02 21:14:08.177513 |
| Duration | 36.65 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
DataHora
Date
Unique
| Distinct | 2256 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.8 KiB |
| Minimum | 2023-01-01 00:00:00 |
|---|---|
| Maximum | 2023-04-04 23:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Data
Date
| Distinct | 94 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.8 KiB |
| Minimum | 2023-01-01 00:00:00 |
|---|---|
| Maximum | 2023-04-04 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Hora
Real number (ℝ)
High correlation Zeros
| Distinct | 24 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.5 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 94 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5.75 |
| median | 11.5 |
| Q3 | 17.25 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11.5 |
Descriptive statistics
| Standard deviation | 6.9237212 |
|---|---|
| Coefficient of variation (CV) | 0.60206272 |
| Kurtosis | -1.2041827 |
| Mean | 11.5 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0 |
| Sum | 25944 |
| Variance | 47.937916 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 94 | 4.2% |
| 1 | 94 | 4.2% |
| 2 | 94 | 4.2% |
| 3 | 94 | 4.2% |
| 4 | 94 | 4.2% |
| 5 | 94 | 4.2% |
| 6 | 94 | 4.2% |
| 7 | 94 | 4.2% |
| 8 | 94 | 4.2% |
| 9 | 94 | 4.2% |
| Other values (14) | 1316 |
| Value | Count | Frequency (%) |
| 0 | 94 | |
| 1 | 94 | |
| 2 | 94 | |
| 3 | 94 | |
| 4 | 94 | |
| 5 | 94 | |
| 6 | 94 | |
| 7 | 94 | |
| 8 | 94 | |
| 9 | 94 |
| Value | Count | Frequency (%) |
| 23 | 94 | |
| 22 | 94 | |
| 21 | 94 | |
| 20 | 94 | |
| 19 | 94 | |
| 18 | 94 | |
| 17 | 94 | |
| 16 | 94 | |
| 15 | 94 | |
| 14 | 94 |
Normal (kWh)
Real number (ℝ)
High correlation Zeros
| Distinct | 709 |
|---|---|
| Distinct (%) | 31.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.26805984 |
| Minimum | 0 |
|---|---|
| Maximum | 3.381 |
| Zeros | 1225 |
| Zeros (%) | 54.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.39875 |
| 95-th percentile | 1.27225 |
| Maximum | 3.381 |
| Range | 3.381 |
| Interquartile range (IQR) | 0.39875 |
Descriptive statistics
| Standard deviation | 0.46432336 |
|---|---|
| Coefficient of variation (CV) | 1.7321631 |
| Kurtosis | 7.1225225 |
| Mean | 0.26805984 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.4579907 |
| Sum | 604.743 |
| Variance | 0.21559618 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1225 | |
| 0.222 | 7 | 0.3% |
| 0.007 | 6 | 0.3% |
| 0.507 | 5 | 0.2% |
| 0.139 | 5 | 0.2% |
| 0.338 | 5 | 0.2% |
| 0.431 | 5 | 0.2% |
| 0.637 | 5 | 0.2% |
| 0.564 | 5 | 0.2% |
| 0.287 | 4 | 0.2% |
| Other values (699) | 984 |
| Value | Count | Frequency (%) |
| 0 | 1225 | |
| 0.001 | 1 | < 0.1% |
| 0.002 | 1 | < 0.1% |
| 0.003 | 1 | < 0.1% |
| 0.004 | 1 | < 0.1% |
| 0.005 | 1 | < 0.1% |
| 0.006 | 3 | 0.1% |
| 0.007 | 6 | 0.3% |
| 0.009 | 4 | 0.2% |
| 0.01 | 4 | 0.2% |
| Value | Count | Frequency (%) |
| 3.381 | 1 | |
| 2.948 | 1 | |
| 2.845 | 1 | |
| 2.782 | 1 | |
| 2.77 | 1 | |
| 2.764 | 1 | |
| 2.651 | 1 | |
| 2.596 | 1 | |
| 2.533 | 1 | |
| 2.506 | 1 |
Horário Económico (kWh)
Real number (ℝ)
High correlation Zeros
| Distinct | 490 |
|---|---|
| Distinct (%) | 21.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.22680895 |
| Minimum | 0 |
|---|---|
| Maximum | 2.771 |
| Zeros | 1317 |
| Zeros (%) | 58.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.336 |
| 95-th percentile | 0.97675 |
| Maximum | 2.771 |
| Range | 2.771 |
| Interquartile range (IQR) | 0.336 |
Descriptive statistics
| Standard deviation | 0.37575217 |
|---|---|
| Coefficient of variation (CV) | 1.6566902 |
| Kurtosis | 9.2471322 |
| Mean | 0.22680895 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.6471707 |
| Sum | 511.681 |
| Variance | 0.14118969 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1317 | |
| 0.244 | 10 | 0.4% |
| 0.246 | 9 | 0.4% |
| 0.305 | 9 | 0.4% |
| 0.254 | 8 | 0.4% |
| 0.306 | 8 | 0.4% |
| 0.256 | 8 | 0.4% |
| 0.251 | 7 | 0.3% |
| 0.3 | 7 | 0.3% |
| 0.297 | 7 | 0.3% |
| Other values (480) | 866 |
| Value | Count | Frequency (%) |
| 0 | 1317 | |
| 0.053 | 1 | < 0.1% |
| 0.145 | 1 | < 0.1% |
| 0.209 | 1 | < 0.1% |
| 0.223 | 1 | < 0.1% |
| 0.224 | 1 | < 0.1% |
| 0.229 | 1 | < 0.1% |
| 0.233 | 2 | 0.1% |
| 0.234 | 3 | 0.1% |
| 0.235 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 2.771 | 1 | |
| 2.7 | 1 | |
| 2.672 | 1 | |
| 2.527 | 1 | |
| 2.499 | 1 | |
| 2.478 | 1 | |
| 2.472 | 1 | |
| 2.468 | 1 | |
| 2.215 | 1 | |
| 2.207 | 1 |
Autoconsumo (kWh)
Real number (ℝ)
High correlation Zeros
| Distinct | 485 |
|---|---|
| Distinct (%) | 21.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.11943883 |
| Minimum | 0 |
|---|---|
| Maximum | 1.161 |
| Zeros | 1263 |
| Zeros (%) | 56.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.23725 |
| 95-th percentile | 0.50525 |
| Maximum | 1.161 |
| Range | 1.161 |
| Interquartile range (IQR) | 0.23725 |
Descriptive statistics
| Standard deviation | 0.19060084 |
|---|---|
| Coefficient of variation (CV) | 1.595803 |
| Kurtosis | 3.7519876 |
| Mean | 0.11943883 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.880032 |
| Sum | 269.454 |
| Variance | 0.036328681 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1263 | |
| 0.001 | 13 | 0.6% |
| 0.003 | 11 | 0.5% |
| 0.004 | 8 | 0.4% |
| 0.002 | 8 | 0.4% |
| 0.251 | 7 | 0.3% |
| 0.255 | 6 | 0.3% |
| 0.241 | 6 | 0.3% |
| 0.007 | 6 | 0.3% |
| 0.305 | 6 | 0.3% |
| Other values (475) | 922 |
| Value | Count | Frequency (%) |
| 0 | 1263 | |
| 0.001 | 13 | 0.6% |
| 0.002 | 8 | 0.4% |
| 0.003 | 11 | 0.5% |
| 0.004 | 8 | 0.4% |
| 0.005 | 6 | 0.3% |
| 0.006 | 5 | 0.2% |
| 0.007 | 6 | 0.3% |
| 0.008 | 4 | 0.2% |
| 0.009 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 1.161 | 1 | |
| 1.07 | 1 | |
| 1.06 | 1 | |
| 0.995 | 2 | |
| 0.981 | 1 | |
| 0.976 | 1 | |
| 0.962 | 1 | |
| 0.954 | 1 | |
| 0.952 | 1 | |
| 0.915 | 1 |
dt
Real number (ℝ)
Missing Uniform
| Distinct | 1752 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.675683 × 109 |
| Minimum | 1.6725312 × 109 |
|---|---|
| Maximum | 1.6788348 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 1.6725312 × 109 |
|---|---|
| 5-th percentile | 1.6728464 × 109 |
| Q1 | 1.6741071 × 109 |
| median | 1.675683 × 109 |
| Q3 | 1.6772589 × 109 |
| 95-th percentile | 1.6785196 × 109 |
| Maximum | 1.6788348 × 109 |
| Range | 6303600 |
| Interquartile range (IQR) | 3151800 |
Descriptive statistics
| Standard deviation | 1821251.4 |
|---|---|
| Coefficient of variation (CV) | 0.0010868711 |
| Kurtosis | -1.2 |
| Mean | 1.675683 × 109 |
| Median Absolute Deviation (MAD) | 1576800 |
| Skewness | -1.9848613 × 10-16 |
| Sum | 2.9357966 × 1012 |
| Variance | 3.3169565 × 1012 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1672570800 | 1 | < 0.1% |
| 1672574400 | 1 | < 0.1% |
| 1672578000 | 1 | < 0.1% |
| 1672581600 | 1 | < 0.1% |
| 1672585200 | 1 | < 0.1% |
| 1672588800 | 1 | < 0.1% |
| 1672592400 | 1 | < 0.1% |
| 1672596000 | 1 | < 0.1% |
| 1672599600 | 1 | < 0.1% |
| 1672603200 | 1 | < 0.1% |
| Other values (1742) | 1742 | |
| (Missing) | 504 | 22.3% |
| Value | Count | Frequency (%) |
| 1672531200 | 1 | |
| 1672534800 | 1 | |
| 1672538400 | 1 | |
| 1672542000 | 1 | |
| 1672545600 | 1 | |
| 1672549200 | 1 | |
| 1672552800 | 1 | |
| 1672556400 | 1 | |
| 1672560000 | 1 | |
| 1672563600 | 1 |
| Value | Count | Frequency (%) |
| 1678834800 | 1 | |
| 1678831200 | 1 | |
| 1678827600 | 1 | |
| 1678824000 | 1 | |
| 1678820400 | 1 | |
| 1678816800 | 1 | |
| 1678813200 | 1 | |
| 1678809600 | 1 | |
| 1678806000 | 1 | |
| 1678802400 | 1 |
dt_iso
Text
Missing
| Distinct | 1752 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Memory size | 149.3 KiB |
Length
| Max length | 29 |
|---|---|
| Median length | 29 |
| Mean length | 29 |
| Min length | 29 |
Unique
| Unique | 1752 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2023-01-01 00:00:00 +0000 UTC |
|---|---|
| 2nd row | 2023-01-01 01:00:00 +0000 UTC |
| 3rd row | 2023-01-01 02:00:00 +0000 UTC |
| 4th row | 2023-01-01 03:00:00 +0000 UTC |
| 5th row | 2023-01-01 04:00:00 +0000 UTC |
| Value | Count | Frequency (%) |
| 0000 | 1752 | |
| utc | 1752 | |
| 11:00:00 | 73 | 1.0% |
| 10:00:00 | 73 | 1.0% |
| 12:00:00 | 73 | 1.0% |
| 13:00:00 | 73 | 1.0% |
| 14:00:00 | 73 | 1.0% |
| 15:00:00 | 73 | 1.0% |
| 16:00:00 | 73 | 1.0% |
| 17:00:00 | 73 | 1.0% |
| Other values (89) | 2920 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 19261 | |
| 2 | 5335 | 10.5% |
| 5256 | 10.3% | |
| : | 3504 | 6.9% |
| - | 3504 | 6.9% |
| 3 | 2547 | 5.0% |
| 1 | 2509 | 4.9% |
| + | 1752 | 3.4% |
| U | 1752 | 3.4% |
| T | 1752 | 3.4% |
| Other values (7) | 3636 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 50808 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19261 | |
| 2 | 5335 | 10.5% |
| 5256 | 10.3% | |
| : | 3504 | 6.9% |
| - | 3504 | 6.9% |
| 3 | 2547 | 5.0% |
| 1 | 2509 | 4.9% |
| + | 1752 | 3.4% |
| U | 1752 | 3.4% |
| T | 1752 | 3.4% |
| Other values (7) | 3636 | 7.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 50808 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19261 | |
| 2 | 5335 | 10.5% |
| 5256 | 10.3% | |
| : | 3504 | 6.9% |
| - | 3504 | 6.9% |
| 3 | 2547 | 5.0% |
| 1 | 2509 | 4.9% |
| + | 1752 | 3.4% |
| U | 1752 | 3.4% |
| T | 1752 | 3.4% |
| Other values (7) | 3636 | 7.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 50808 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 19261 | |
| 2 | 5335 | 10.5% |
| 5256 | 10.3% | |
| : | 3504 | 6.9% |
| - | 3504 | 6.9% |
| 3 | 2547 | 5.0% |
| 1 | 2509 | 4.9% |
| + | 1752 | 3.4% |
| U | 1752 | 3.4% |
| T | 1752 | 3.4% |
| Other values (7) | 3636 | 7.2% |
city_name
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Memory size | 120.1 KiB |
| local |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | local |
|---|---|
| 2nd row | local |
| 3rd row | local |
| 4th row | local |
| 5th row | local |
Common Values
| Value | Count | Frequency (%) |
| local | 1752 | |
| (Missing) | 504 | 22.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| local | 1752 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 3504 | |
| o | 1752 | |
| c | 1752 | |
| a | 1752 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8760 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 3504 | |
| o | 1752 | |
| c | 1752 | |
| a | 1752 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8760 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 3504 | |
| o | 1752 | |
| c | 1752 | |
| a | 1752 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8760 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 3504 | |
| o | 1752 | |
| c | 1752 | |
| a | 1752 |
temp
Real number (ℝ)
High correlation Missing
| Distinct | 889 |
|---|---|
| Distinct (%) | 50.7% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.599606 |
| Minimum | 0.93 |
|---|---|
| Maximum | 20.61 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0.93 |
|---|---|
| 5-th percentile | 4.1955 |
| Q1 | 7.8775 |
| median | 10.95 |
| Q3 | 13.2925 |
| 95-th percentile | 16.39 |
| Maximum | 20.61 |
| Range | 19.68 |
| Interquartile range (IQR) | 5.415 |
Descriptive statistics
| Standard deviation | 3.7151563 |
|---|---|
| Coefficient of variation (CV) | 0.35049947 |
| Kurtosis | -0.43883227 |
| Mean | 10.599606 |
| Median Absolute Deviation (MAD) | 2.6 |
| Skewness | -0.11427813 |
| Sum | 18570.51 |
| Variance | 13.802386 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.98 | 18 | 0.8% |
| 13.49 | 16 | 0.7% |
| 14.59 | 14 | 0.6% |
| 12.91 | 12 | 0.5% |
| 12.4 | 11 | 0.5% |
| 11.29 | 10 | 0.4% |
| 12.38 | 9 | 0.4% |
| 13.55 | 9 | 0.4% |
| 11.9 | 8 | 0.4% |
| 13.01 | 8 | 0.4% |
| Other values (879) | 1637 | |
| (Missing) | 504 | 22.3% |
| Value | Count | Frequency (%) |
| 0.93 | 1 | |
| 1.04 | 1 | |
| 1.12 | 1 | |
| 1.22 | 1 | |
| 1.78 | 1 | |
| 1.81 | 1 | |
| 1.98 | 1 | |
| 2.26 | 1 | |
| 2.27 | 1 | |
| 2.29 | 1 |
| Value | Count | Frequency (%) |
| 20.61 | 1 | |
| 20.47 | 1 | |
| 20.45 | 1 | |
| 20.3 | 1 | |
| 20.25 | 1 | |
| 20.21 | 1 | |
| 19.96 | 2 | |
| 19.72 | 1 | |
| 19.7 | 2 | |
| 19.57 | 1 |
feels_like
Real number (ℝ)
High correlation Missing
| Distinct | 1007 |
|---|---|
| Distinct (%) | 57.5% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.5432648 |
| Minimum | -1.79 |
|---|---|
| Maximum | 19.79 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 12 |
| Negative (%) | 0.5% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | -1.79 |
|---|---|
| 5-th percentile | 2.3255 |
| Q1 | 6.2175 |
| median | 10.135 |
| Q3 | 12.7425 |
| 95-th percentile | 15.609 |
| Maximum | 19.79 |
| Range | 21.58 |
| Interquartile range (IQR) | 6.525 |
Descriptive statistics
| Standard deviation | 4.1912244 |
|---|---|
| Coefficient of variation (CV) | 0.4391814 |
| Kurtosis | -0.60687299 |
| Mean | 9.5432648 |
| Median Absolute Deviation (MAD) | 3.09 |
| Skewness | -0.25248791 |
| Sum | 16719.8 |
| Variance | 17.566362 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13.36 | 8 | 0.4% |
| 11.77 | 8 | 0.4% |
| 10.93 | 8 | 0.4% |
| 12.79 | 8 | 0.4% |
| 15.11 | 7 | 0.3% |
| 9.58 | 7 | 0.3% |
| 12.85 | 7 | 0.3% |
| 10.27 | 7 | 0.3% |
| 12.2 | 7 | 0.3% |
| 12.18 | 7 | 0.3% |
| Other values (997) | 1678 | |
| (Missing) | 504 | 22.3% |
| Value | Count | Frequency (%) |
| -1.79 | 1 | |
| -1.75 | 1 | |
| -1.49 | 1 | |
| -0.87 | 1 | |
| -0.73 | 1 | |
| -0.57 | 1 | |
| -0.24 | 1 | |
| -0.22 | 1 | |
| -0.11 | 2 | |
| -0.09 | 1 |
| Value | Count | Frequency (%) |
| 19.79 | 1 | |
| 19.7 | 1 | |
| 19.51 | 1 | |
| 19.48 | 1 | |
| 19.33 | 1 | |
| 19.25 | 1 | |
| 19.21 | 1 | |
| 19.2 | 1 | |
| 19.03 | 1 | |
| 18.92 | 1 |
temp_min
Real number (ℝ)
High correlation Missing
| Distinct | 169 |
|---|---|
| Distinct (%) | 9.6% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1779167 |
| Minimum | -0.85 |
|---|---|
| Maximum | 20.01 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 13 |
| Negative (%) | 0.6% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | -0.85 |
|---|---|
| 5-th percentile | 1.963 |
| Q1 | 6.2475 |
| median | 9.71 |
| Q3 | 12.32 |
| 95-th percentile | 14.72 |
| Maximum | 20.01 |
| Range | 20.86 |
| Interquartile range (IQR) | 6.0725 |
Descriptive statistics
| Standard deviation | 4.0211764 |
|---|---|
| Coefficient of variation (CV) | 0.43813608 |
| Kurtosis | -0.60244543 |
| Mean | 9.1779167 |
| Median Absolute Deviation (MAD) | 3.01 |
| Skewness | -0.28607629 |
| Sum | 16079.71 |
| Variance | 16.16986 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.79 | 41 | 1.8% |
| 12.23 | 38 | 1.7% |
| 10.66 | 36 | 1.6% |
| 13.43 | 34 | 1.5% |
| 9.54 | 33 | 1.5% |
| 9.23 | 32 | 1.4% |
| 7.57 | 32 | 1.4% |
| 12.72 | 31 | 1.4% |
| 4.71 | 28 | 1.2% |
| 11.21 | 28 | 1.2% |
| Other values (159) | 1419 | |
| (Missing) | 504 | 22.3% |
| Value | Count | Frequency (%) |
| -0.85 | 3 | 0.1% |
| -0.29 | 8 | |
| -0.28 | 1 | < 0.1% |
| -0.21 | 1 | < 0.1% |
| 0.26 | 6 | |
| 0.34 | 2 | 0.1% |
| 0.72 | 10 | |
| 0.82 | 9 | |
| 0.9 | 10 | |
| 1.38 | 8 |
| Value | Count | Frequency (%) |
| 20.01 | 1 | < 0.1% |
| 19.45 | 1 | < 0.1% |
| 18.9 | 1 | < 0.1% |
| 18.72 | 2 | 0.1% |
| 18.6 | 1 | < 0.1% |
| 18.34 | 2 | 0.1% |
| 17.79 | 2 | 0.1% |
| 17.72 | 6 | |
| 17.37 | 1 | < 0.1% |
| 17.32 | 4 |
temp_max
Real number (ℝ)
High correlation Missing
| Distinct | 174 |
|---|---|
| Distinct (%) | 9.9% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.643813 |
| Minimum | 3.34 |
|---|---|
| Maximum | 22.01 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 3.34 |
|---|---|
| 5-th percentile | 5.66 |
| Q1 | 8.9 |
| median | 11.82 |
| Q3 | 14.04 |
| 95-th percentile | 17.01 |
| Maximum | 22.01 |
| Range | 18.67 |
| Interquartile range (IQR) | 5.14 |
Descriptive statistics
| Standard deviation | 3.5968823 |
|---|---|
| Coefficient of variation (CV) | 0.30890932 |
| Kurtosis | -0.3703718 |
| Mean | 11.643813 |
| Median Absolute Deviation (MAD) | 2.72 |
| Skewness | -0.01743194 |
| Sum | 20399.96 |
| Variance | 12.937563 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13.82 | 95 | 4.2% |
| 11.82 | 74 | 3.3% |
| 12.82 | 72 | 3.2% |
| 10.82 | 49 | 2.2% |
| 14.82 | 44 | 2.0% |
| 15.82 | 34 | 1.5% |
| 6.82 | 29 | 1.3% |
| 9.82 | 26 | 1.2% |
| 13.72 | 26 | 1.2% |
| 8.82 | 26 | 1.2% |
| Other values (164) | 1277 | |
| (Missing) | 504 | 22.3% |
| Value | Count | Frequency (%) |
| 3.34 | 1 | < 0.1% |
| 3.43 | 2 | 0.1% |
| 3.72 | 1 | < 0.1% |
| 3.9 | 2 | 0.1% |
| 3.99 | 6 | |
| 4.04 | 2 | 0.1% |
| 4.23 | 1 | < 0.1% |
| 4.45 | 9 | |
| 4.54 | 10 | |
| 4.59 | 4 | 0.2% |
| Value | Count | Frequency (%) |
| 22.01 | 2 | 0.1% |
| 21.82 | 1 | < 0.1% |
| 21.45 | 2 | 0.1% |
| 21.38 | 2 | 0.1% |
| 21.12 | 1 | < 0.1% |
| 20.9 | 2 | 0.1% |
| 20.82 | 3 | |
| 20.7 | 2 | 0.1% |
| 20.34 | 5 | |
| 20.26 | 3 |
pressure
Real number (ℝ)
Missing
| Distinct | 31 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1023.4937 |
| Minimum | 1006 |
|---|---|
| Maximum | 1036 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 1006 |
|---|---|
| 5-th percentile | 1010 |
| Q1 | 1020 |
| median | 1024 |
| Q3 | 1029 |
| 95-th percentile | 1033 |
| Maximum | 1036 |
| Range | 30 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 6.6508731 |
|---|---|
| Coefficient of variation (CV) | 0.006498206 |
| Kurtosis | -0.38232493 |
| Mean | 1023.4937 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.60862297 |
| Sum | 1793161 |
| Variance | 44.234112 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1028 | 142 | 6.3% |
| 1030 | 117 | 5.2% |
| 1024 | 112 | 5.0% |
| 1027 | 111 | 4.9% |
| 1029 | 110 | 4.9% |
| 1021 | 100 | 4.4% |
| 1023 | 95 | 4.2% |
| 1026 | 88 | 3.9% |
| 1025 | 81 | 3.6% |
| 1020 | 75 | 3.3% |
| Other values (21) | 721 | |
| (Missing) | 504 |
| Value | Count | Frequency (%) |
| 1006 | 3 | 0.1% |
| 1007 | 6 | 0.3% |
| 1008 | 24 | |
| 1009 | 27 | |
| 1010 | 38 | |
| 1011 | 31 | |
| 1012 | 42 | |
| 1013 | 32 | |
| 1014 | 29 | |
| 1015 | 28 |
| Value | Count | Frequency (%) |
| 1036 | 3 | 0.1% |
| 1035 | 8 | 0.4% |
| 1034 | 27 | 1.2% |
| 1033 | 61 | |
| 1032 | 61 | |
| 1031 | 58 | |
| 1030 | 117 | |
| 1029 | 110 | |
| 1028 | 142 | |
| 1027 | 111 |
sea_level
Unsupported
Missing Rejected Unsupported
| Missing | 2256 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 17.8 KiB |
grnd_level
Unsupported
Missing Rejected Unsupported
| Missing | 2256 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 17.8 KiB |
humidity
Real number (ℝ)
High correlation Missing
| Distinct | 71 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75.63984 |
| Minimum | 23 |
|---|---|
| Maximum | 97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 23 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 62 |
| median | 81 |
| Q3 | 91 |
| 95-th percentile | 95 |
| Maximum | 97 |
| Range | 74 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 17.415468 |
|---|---|
| Coefficient of variation (CV) | 0.230242 |
| Kurtosis | -0.70029446 |
| Mean | 75.63984 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | -0.65459207 |
| Sum | 132521 |
| Variance | 303.29854 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 94 | 143 | 6.3% |
| 95 | 103 | 4.6% |
| 93 | 76 | 3.4% |
| 96 | 65 | 2.9% |
| 85 | 49 | 2.2% |
| 86 | 48 | 2.1% |
| 92 | 47 | 2.1% |
| 84 | 47 | 2.1% |
| 91 | 47 | 2.1% |
| 90 | 43 | 1.9% |
| Other values (61) | 1084 | |
| (Missing) | 504 |
| Value | Count | Frequency (%) |
| 23 | 1 | < 0.1% |
| 25 | 2 | 0.1% |
| 26 | 2 | 0.1% |
| 30 | 1 | < 0.1% |
| 31 | 2 | 0.1% |
| 32 | 3 | 0.1% |
| 33 | 1 | < 0.1% |
| 34 | 2 | 0.1% |
| 35 | 5 | |
| 36 | 9 |
| Value | Count | Frequency (%) |
| 97 | 2 | 0.1% |
| 96 | 65 | |
| 95 | 103 | |
| 94 | 143 | |
| 93 | 76 | |
| 92 | 47 | 2.1% |
| 91 | 47 | 2.1% |
| 90 | 43 | 1.9% |
| 89 | 42 | 1.9% |
| 88 | 32 | 1.4% |
wind_speed
Real number (ℝ)
Missing
| Distinct | 512 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.873613 |
| Minimum | 0.12 |
|---|---|
| Maximum | 10.32 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0.12 |
|---|---|
| 5-th percentile | 1.02 |
| Q1 | 1.8 |
| median | 2.49 |
| Q3 | 3.5 |
| 95-th percentile | 6.507 |
| Maximum | 10.32 |
| Range | 10.2 |
| Interquartile range (IQR) | 1.7 |
Descriptive statistics
| Standard deviation | 1.6204501 |
|---|---|
| Coefficient of variation (CV) | 0.56390685 |
| Kurtosis | 2.5172904 |
| Mean | 2.873613 |
| Median Absolute Deviation (MAD) | 0.78 |
| Skewness | 1.4667235 |
| Sum | 5034.57 |
| Variance | 2.6258584 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.8 | 13 | 0.6% |
| 2.87 | 13 | 0.6% |
| 1.87 | 13 | 0.6% |
| 1.96 | 13 | 0.6% |
| 2.48 | 12 | 0.5% |
| 1.73 | 12 | 0.5% |
| 1.79 | 12 | 0.5% |
| 1.86 | 11 | 0.5% |
| 2.2 | 11 | 0.5% |
| 2.83 | 11 | 0.5% |
| Other values (502) | 1631 | |
| (Missing) | 504 | 22.3% |
| Value | Count | Frequency (%) |
| 0.12 | 1 | |
| 0.16 | 1 | |
| 0.22 | 1 | |
| 0.31 | 2 | |
| 0.34 | 1 | |
| 0.35 | 1 | |
| 0.37 | 1 | |
| 0.39 | 2 | |
| 0.42 | 1 | |
| 0.44 | 1 |
| Value | Count | Frequency (%) |
| 10.32 | 1 | |
| 9.87 | 1 | |
| 9.56 | 1 | |
| 9.53 | 1 | |
| 9.48 | 1 | |
| 9.38 | 1 | |
| 9.34 | 1 | |
| 9.25 | 1 | |
| 9.17 | 1 | |
| 9.12 | 1 |
rain_1h
Real number (ℝ)
High correlation Missing
| Distinct | 120 |
|---|---|
| Distinct (%) | 58.3% |
| Missing | 2050 |
| Missing (%) | 90.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0250971 |
| Minimum | 0.11 |
|---|---|
| Maximum | 6.38 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0.11 |
|---|---|
| 5-th percentile | 0.13 |
| Q1 | 0.25 |
| median | 0.565 |
| Q3 | 1.245 |
| 95-th percentile | 3.63 |
| Maximum | 6.38 |
| Range | 6.27 |
| Interquartile range (IQR) | 0.995 |
Descriptive statistics
| Standard deviation | 1.2096175 |
|---|---|
| Coefficient of variation (CV) | 1.1800028 |
| Kurtosis | 5.2551679 |
| Mean | 1.0250971 |
| Median Absolute Deviation (MAD) | 0.395 |
| Skewness | 2.2058189 |
| Sum | 211.17 |
| Variance | 1.4631744 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.15 | 7 | 0.3% |
| 0.13 | 6 | 0.3% |
| 0.11 | 5 | 0.2% |
| 0.22 | 5 | 0.2% |
| 0.19 | 4 | 0.2% |
| 0.12 | 4 | 0.2% |
| 0.31 | 4 | 0.2% |
| 0.14 | 4 | 0.2% |
| 0.57 | 4 | 0.2% |
| 0.33 | 4 | 0.2% |
| Other values (110) | 159 | 7.0% |
| (Missing) | 2050 |
| Value | Count | Frequency (%) |
| 0.11 | 5 | |
| 0.12 | 4 | |
| 0.13 | 6 | |
| 0.14 | 4 | |
| 0.15 | 7 | |
| 0.16 | 2 | 0.1% |
| 0.17 | 2 | 0.1% |
| 0.18 | 2 | 0.1% |
| 0.19 | 4 | |
| 0.2 | 3 |
| Value | Count | Frequency (%) |
| 6.38 | 1 | |
| 6.16 | 1 | |
| 6.11 | 1 | |
| 5.42 | 1 | |
| 4.96 | 1 | |
| 4.48 | 1 | |
| 4.07 | 1 | |
| 3.86 | 1 | |
| 3.79 | 1 | |
| 3.76 | 1 |
clouds_all
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 99 |
|---|---|
| Distinct (%) | 5.7% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.489726 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 504 |
| Zeros (%) | 22.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 35 |
| Q3 | 96 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 96 |
Descriptive statistics
| Standard deviation | 42.972438 |
|---|---|
| Coefficient of variation (CV) | 0.96589576 |
| Kurtosis | -1.7393436 |
| Mean | 44.489726 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 0.20532117 |
| Sum | 77946 |
| Variance | 1846.6304 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 504 | |
| 100 | 335 | |
| 99 | 48 | 2.1% |
| 1 | 45 | 2.0% |
| 2 | 37 | 1.6% |
| 5 | 36 | 1.6% |
| 4 | 35 | 1.6% |
| 3 | 33 | 1.5% |
| 98 | 30 | 1.3% |
| 96 | 23 | 1.0% |
| Other values (89) | 626 | |
| (Missing) | 504 |
| Value | Count | Frequency (%) |
| 0 | 504 | |
| 1 | 45 | 2.0% |
| 2 | 37 | 1.6% |
| 3 | 33 | 1.5% |
| 4 | 35 | 1.6% |
| 5 | 36 | 1.6% |
| 6 | 17 | 0.8% |
| 7 | 12 | 0.5% |
| 8 | 12 | 0.5% |
| 9 | 15 | 0.7% |
| Value | Count | Frequency (%) |
| 100 | 335 | |
| 99 | 48 | 2.1% |
| 98 | 30 | 1.3% |
| 97 | 22 | 1.0% |
| 96 | 23 | 1.0% |
| 95 | 10 | 0.4% |
| 94 | 13 | 0.6% |
| 93 | 13 | 0.6% |
| 92 | 13 | 0.6% |
| 91 | 9 | 0.4% |
weather_description
Categorical
High correlation Missing
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 504 |
| Missing (%) | 22.3% |
| Memory size | 133.0 KiB |
| sky is clear | |
|---|---|
| overcast clouds | |
| light rain | |
| broken clouds | |
| scattered clouds | |
| Other values (3) |
Length
| Max length | 20 |
|---|---|
| Median length | 16 |
| Mean length | 12.524543 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | moderate rain |
|---|---|
| 2nd row | moderate rain |
| 3rd row | moderate rain |
| 4th row | moderate rain |
| 5th row | moderate rain |
Common Values
| Value | Count | Frequency (%) |
| sky is clear | 739 | |
| overcast clouds | 305 | |
| light rain | 299 | |
| broken clouds | 149 | 6.6% |
| scattered clouds | 118 | 5.2% |
| few clouds | 70 | 3.1% |
| moderate rain | 65 | 2.9% |
| heavy intensity rain | 7 | 0.3% |
| (Missing) | 504 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| sky | 739 | |
| is | 739 | |
| clear | 739 | |
| clouds | 642 | |
| rain | 371 | |
| overcast | 305 | |
| light | 299 | |
| broken | 149 | 3.5% |
| scattered | 118 | 2.8% |
| few | 70 | 1.6% |
| Other values (3) | 79 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 2550 | |
| 2498 | ||
| c | 1804 | 8.2% |
| r | 1747 | 8.0% |
| l | 1680 | 7.7% |
| e | 1643 | 7.5% |
| a | 1605 | 7.3% |
| i | 1423 | 6.5% |
| o | 1161 | 5.3% |
| t | 919 | 4.2% |
| Other values (12) | 4913 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21943 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 2550 | |
| 2498 | ||
| c | 1804 | 8.2% |
| r | 1747 | 8.0% |
| l | 1680 | 7.7% |
| e | 1643 | 7.5% |
| a | 1605 | 7.3% |
| i | 1423 | 6.5% |
| o | 1161 | 5.3% |
| t | 919 | 4.2% |
| Other values (12) | 4913 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21943 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 2550 | |
| 2498 | ||
| c | 1804 | 8.2% |
| r | 1747 | 8.0% |
| l | 1680 | 7.7% |
| e | 1643 | 7.5% |
| a | 1605 | 7.3% |
| i | 1423 | 6.5% |
| o | 1161 | 5.3% |
| t | 919 | 4.2% |
| Other values (12) | 4913 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21943 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 2550 | |
| 2498 | ||
| c | 1804 | 8.2% |
| r | 1747 | 8.0% |
| l | 1680 | 7.7% |
| e | 1643 | 7.5% |
| a | 1605 | 7.3% |
| i | 1423 | 6.5% |
| o | 1161 | 5.3% |
| t | 919 | 4.2% |
| Other values (12) | 4913 |
Interactions
Correlations
| Autoconsumo (kWh) | Hora | Horário Económico (kWh) | Normal (kWh) | clouds_all | dt | feels_like | humidity | pressure | rain_1h | temp | temp_max | temp_min | weather_description | wind_speed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Autoconsumo (kWh) | 1.000 | 0.095 | -0.621 | 0.198 | -0.108 | 0.083 | 0.302 | -0.364 | 0.054 | -0.092 | 0.344 | 0.336 | 0.310 | 0.085 | 0.065 |
| Hora | 0.095 | 1.000 | -0.414 | 0.518 | -0.047 | 0.014 | 0.246 | -0.196 | -0.013 | -0.143 | 0.262 | 0.283 | 0.275 | 0.000 | -0.043 |
| Horário Económico (kWh) | -0.621 | -0.414 | 1.000 | -0.696 | 0.008 | 0.009 | -0.352 | 0.259 | -0.003 | -0.020 | -0.384 | -0.382 | -0.382 | 0.000 | -0.051 |
| Normal (kWh) | 0.198 | 0.518 | -0.696 | 1.000 | 0.072 | -0.016 | 0.237 | -0.092 | -0.079 | -0.068 | 0.250 | 0.258 | 0.276 | 0.034 | 0.040 |
| clouds_all | -0.108 | -0.047 | 0.008 | 0.072 | 1.000 | -0.015 | 0.343 | 0.611 | -0.425 | 0.449 | 0.285 | 0.253 | 0.336 | 0.670 | 0.223 |
| dt | 0.083 | 0.014 | 0.009 | -0.016 | -0.015 | 1.000 | 0.181 | -0.232 | -0.433 | -0.319 | 0.179 | 0.172 | 0.190 | 0.309 | -0.020 |
| feels_like | 0.302 | 0.246 | -0.352 | 0.237 | 0.343 | 0.181 | 1.000 | -0.020 | -0.155 | 0.316 | 0.989 | 0.954 | 0.962 | 0.162 | 0.168 |
| humidity | -0.364 | -0.196 | 0.259 | -0.092 | 0.611 | -0.232 | -0.020 | 1.000 | -0.255 | 0.291 | -0.103 | -0.114 | -0.022 | 0.270 | 0.209 |
| pressure | 0.054 | -0.013 | -0.003 | -0.079 | -0.425 | -0.433 | -0.155 | -0.255 | 1.000 | -0.443 | -0.131 | -0.123 | -0.195 | 0.247 | -0.271 |
| rain_1h | -0.092 | -0.143 | -0.020 | -0.068 | 0.449 | -0.319 | 0.316 | 0.291 | -0.443 | 1.000 | 0.320 | 0.297 | 0.358 | 0.919 | 0.436 |
| temp | 0.344 | 0.262 | -0.384 | 0.250 | 0.285 | 0.179 | 0.989 | -0.103 | -0.131 | 0.320 | 1.000 | 0.970 | 0.967 | 0.150 | 0.201 |
| temp_max | 0.336 | 0.283 | -0.382 | 0.258 | 0.253 | 0.172 | 0.954 | -0.114 | -0.123 | 0.297 | 0.970 | 1.000 | 0.947 | 0.161 | 0.218 |
| temp_min | 0.310 | 0.275 | -0.382 | 0.276 | 0.336 | 0.190 | 0.962 | -0.022 | -0.195 | 0.358 | 0.967 | 0.947 | 1.000 | 0.164 | 0.223 |
| weather_description | 0.085 | 0.000 | 0.000 | 0.034 | 0.670 | 0.309 | 0.162 | 0.270 | 0.247 | 0.919 | 0.150 | 0.161 | 0.164 | 1.000 | 0.269 |
| wind_speed | 0.065 | -0.043 | -0.051 | 0.040 | 0.223 | -0.020 | 0.168 | 0.209 | -0.271 | 0.436 | 0.201 | 0.218 | 0.223 | 0.269 | 1.000 |
Missing values
Sample
| DataHora | Data | Hora | Normal (kWh) | Horário Económico (kWh) | Autoconsumo (kWh) | dt | dt_iso | city_name | temp | feels_like | temp_min | temp_max | pressure | sea_level | grnd_level | humidity | wind_speed | rain_1h | clouds_all | weather_description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023-01-01 00:00:00 | 2023-01-01 | 0 | 0.000 | 0.467 | 0.000 | 1.672531e+09 | 2023-01-01 00:00:00 +0000 UTC | local | 12.93 | 12.76 | 12.72 | 13.43 | 1019.0 | NaN | NaN | 95.0 | 2.02 | 3.72 | 100.0 | moderate rain |
| 1 | 2023-01-01 01:00:00 | 2023-01-01 | 1 | 0.000 | 0.577 | 0.000 | 1.672535e+09 | 2023-01-01 01:00:00 +0000 UTC | local | 13.49 | 13.38 | 13.43 | 13.90 | 1018.0 | NaN | NaN | 95.0 | 2.18 | 3.26 | 100.0 | moderate rain |
| 2 | 2023-01-01 02:00:00 | 2023-01-01 | 2 | 0.000 | 0.346 | 0.000 | 1.672538e+09 | 2023-01-01 02:00:00 +0000 UTC | local | 13.55 | 13.44 | 13.48 | 14.82 | 1017.0 | NaN | NaN | 95.0 | 2.88 | 2.44 | 100.0 | moderate rain |
| 3 | 2023-01-01 03:00:00 | 2023-01-01 | 3 | 0.000 | 0.270 | 0.000 | 1.672542e+09 | 2023-01-01 03:00:00 +0000 UTC | local | 13.61 | 13.51 | 12.01 | 14.82 | 1016.0 | NaN | NaN | 95.0 | 3.63 | 1.74 | 100.0 | moderate rain |
| 4 | 2023-01-01 04:00:00 | 2023-01-01 | 4 | 0.000 | 0.252 | 0.000 | 1.672546e+09 | 2023-01-01 04:00:00 +0000 UTC | local | 13.59 | 13.49 | 12.01 | 14.82 | 1015.0 | NaN | NaN | 95.0 | 4.58 | 1.13 | 100.0 | moderate rain |
| 5 | 2023-01-01 05:00:00 | 2023-01-01 | 5 | 0.000 | 0.255 | 0.000 | 1.672549e+09 | 2023-01-01 05:00:00 +0000 UTC | local | 13.70 | 13.61 | 13.12 | 15.82 | 1014.0 | NaN | NaN | 95.0 | 6.36 | 1.23 | 99.0 | moderate rain |
| 6 | 2023-01-01 06:00:00 | 2023-01-01 | 6 | 0.000 | 0.256 | 0.000 | 1.672553e+09 | 2023-01-01 06:00:00 +0000 UTC | local | 14.22 | 14.18 | 14.04 | 16.12 | 1014.0 | NaN | NaN | 95.0 | 8.55 | 1.20 | 100.0 | moderate rain |
| 7 | 2023-01-01 07:00:00 | 2023-01-01 | 7 | 0.000 | 0.263 | 0.000 | 1.672556e+09 | 2023-01-01 07:00:00 +0000 UTC | local | 15.30 | 15.31 | 14.79 | 16.82 | 1015.0 | NaN | NaN | 93.0 | 8.37 | 2.20 | 100.0 | moderate rain |
| 8 | 2023-01-01 08:00:00 | 2023-01-01 | 8 | 0.275 | 0.000 | 0.002 | 1.672560e+09 | 2023-01-01 08:00:00 +0000 UTC | local | 16.80 | 16.55 | 15.66 | 16.82 | 1015.0 | NaN | NaN | 77.0 | 8.29 | 2.20 | 100.0 | moderate rain |
| 9 | 2023-01-01 09:00:00 | 2023-01-01 | 9 | 0.331 | 0.000 | 0.000 | 1.672564e+09 | 2023-01-01 09:00:00 +0000 UTC | local | 16.61 | 16.31 | 14.72 | 16.82 | 1014.0 | NaN | NaN | 76.0 | 8.38 | 2.13 | 100.0 | moderate rain |
| DataHora | Data | Hora | Normal (kWh) | Horário Económico (kWh) | Autoconsumo (kWh) | dt | dt_iso | city_name | temp | feels_like | temp_min | temp_max | pressure | sea_level | grnd_level | humidity | wind_speed | rain_1h | clouds_all | weather_description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2246 | 2023-04-04 14:00:00 | 2023-04-04 | 14 | 0.000 | 0.000 | 0.321 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2247 | 2023-04-04 15:00:00 | 2023-04-04 | 15 | 0.000 | 0.000 | 0.319 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2248 | 2023-04-04 16:00:00 | 2023-04-04 | 16 | 0.000 | 0.000 | 0.307 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2249 | 2023-04-04 17:00:00 | 2023-04-04 | 17 | 0.000 | 0.000 | 0.330 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2250 | 2023-04-04 18:00:00 | 2023-04-04 | 18 | 0.207 | 0.000 | 0.137 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2251 | 2023-04-04 19:00:00 | 2023-04-04 | 19 | 0.953 | 0.000 | 0.012 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2252 | 2023-04-04 20:00:00 | 2023-04-04 | 20 | 0.915 | 0.000 | 0.000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2253 | 2023-04-04 21:00:00 | 2023-04-04 | 21 | 0.479 | 0.000 | 0.000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2254 | 2023-04-04 22:00:00 | 2023-04-04 | 22 | 0.000 | 0.497 | 0.000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2255 | 2023-04-04 23:00:00 | 2023-04-04 | 23 | 0.000 | 0.487 | 0.000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |